﻿/*
#------------------------------------------------------------------------------
#-- Program Name:	[dbo].[tblMSX_sql_version]
#-- Purpose:		Defines the human readable text that you want to see in
#--					reports for any given major/minor database version.
#--	Last Update:	08/23/2011
#--					For a complete history - please review comments in Version
#--					Control.
#------------------------------------------------------------------------------
*/
CREATE TABLE [dbo].[tblMSX_sql_version]
(
	[ver_id]						INT								IDENTITY (1, 1) NOT NULL,
	[ver_major_ro]					INT								NOT NULL,
	[ver_minor_ro]					INT								NOT NULL,
	[ver_description]				VARCHAR (20)					NOT NULL,
	[ver_current_sp_version] VARCHAR(20) NULL, 
	[ver_current_version] VARCHAR(20) NULL, 
	CONSTRAINT						[PK_tblMSX_sql_version]			PRIMARY KEY CLUSTERED ([ver_id] ASC)
)